hive -e "
use credit;

CREATE TABLE IF NOT EXISTS dm_rk (
    addrname STRING COMMENT '地址名称',
    product_name STRING COMMENT '产品名称',
    s_amt INT COMMENT '总金额',
    r_n INT COMMENT '排名',
    etl_dt STRING COMMENT '抽取日期'
)row format delimited fields terminated by ','
location '/warehouse/credit/dm/dm_rk';
"
